SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 54617: SAS® Enterprise Guide® 6.1 might generate incorrect syntax when you import comma-delimited text files

DetailsHotfixAboutRate It

When you import a CSV file using SAS Enterprise Guide 6.1_M1, the import task does not generate the correct code when Rename columns to comply with SAS naming conventions is selected.

Here is an example of the incorrect code:

DATA WORK.input;
    LENGTH
        '''col1 with blank''n'n   8
        col2_no_blank      8
        '''col3 with blank''n'n   8 ;
    INFILE '/tmp/SAS_work1B6C0000782A_sbxxab2/#LN00014'
    INPUT
        '''col1 with blank''n'n : ?? BEST1.
        col2_no_blank    : ?? BEST1.
        '''col3 with blank''n'n : ?? BEST1. ;
RUN;

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Enterprise GuideWindows 7 Ultimate x646.1_M17.119.4 TS1M19.4 TS1M1
Windows 7 Ultimate 32 bit6.1_M17.119.4 TS1M19.4 TS1M1
Windows 7 Professional x646.1_M17.119.4 TS1M19.4 TS1M1
Windows 7 Professional 32 bit6.1_M17.119.4 TS1M19.4 TS1M1
Windows 7 Home Premium x646.1_M17.119.4 TS1M19.4 TS1M1
Windows 7 Home Premium 32 bit6.1_M17.119.4 TS1M19.4 TS1M1
Windows 7 Enterprise x646.1_M17.119.4 TS1M19.4 TS1M1
Windows 7 Enterprise 32 bit6.1_M17.119.4 TS1M19.4 TS1M1
Microsoft Windows Server 2012 Std6.1_M17.119.4 TS1M19.4 TS1M1
Microsoft Windows Server 2012 R2 Std6.1_M17.119.4 TS1M19.4 TS1M1
Microsoft Windows Server 2012 R2 Datacenter6.1_M17.119.4 TS1M19.4 TS1M1
Microsoft Windows Server 2012 Datacenter6.1_M17.119.4 TS1M19.4 TS1M1
Microsoft Windows Server 2008 for x646.1_M17.119.4 TS1M19.4 TS1M1
Microsoft Windows Server 2008 R26.1_M17.119.4 TS1M19.4 TS1M1
Microsoft Windows Server 20086.1_M17.119.4 TS1M19.4 TS1M1
Microsoft Windows 8.1 Pro 32-bit6.1_M17.119.4 TS1M19.4 TS1M1
Microsoft Windows 8.1 Pro6.1_M17.119.4 TS1M19.4 TS1M1
Microsoft Windows 8.1 Enterprise x646.1_M17.119.4 TS1M19.4 TS1M1
Microsoft Windows 8.1 Enterprise 32-bit6.1_M17.119.4 TS1M19.4 TS1M1
Microsoft Windows 8 Pro x646.1_M17.119.4 TS1M19.4 TS1M1
Microsoft Windows 8 Pro 32-bit6.1_M17.119.4 TS1M19.4 TS1M1
Microsoft Windows 8 Enterprise x646.1_M17.119.4 TS1M19.4 TS1M1
Microsoft Windows 8 Enterprise 32-bit6.1_M17.119.4 TS1M19.4 TS1M1
Microsoft® Windows® for x646.1_M17.119.4 TS1M19.4 TS1M1
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.